██    ██ ██    ██  ██████  ██  ██████  ██    ██ ███████ ██████  ██    ██ 
     ██  ██  ██    ██ ██       ██ ██    ██ ██    ██ ██      ██   ██  ██  ██  
      ████   ██    ██ ██   ███ ██ ██    ██ ██    ██ █████   ██████    ████   
       ██    ██    ██ ██    ██ ██ ██ ▄▄ ██ ██    ██ ██      ██   ██    ██    
       ██     ██████   ██████  ██  ██████   ██████  ███████ ██   ██    ██    
                                      ▀▀
Cards - Execution started 05/02/2024 05:02 UTC
By Guilherme Ruiz

Table of Contents ¶

  • 1  Data aquisition
    • 1.1  Fetch online data
    • 1.2  Merge data
  • 2  Check changes
    • 2.1  Load previous data
    • 2.2  Generate changelog
    • 2.3  Save data
  • 3  Data visualization
    • 3.1  Full data
    • 3.2  Card types
    • 3.3  Monsters
      • 3.3.1  Attributes
      • 3.3.2  Primary types
        • 3.3.2.1  Has effect discrimination
        • 3.3.2.2  Is pendulum discrimination
        • 3.3.2.3  By attribute
      • 3.3.3  Secondary types
        • 3.3.3.1  By attribute
        • 3.3.3.2  By secondary type
      • 3.3.4  Monster types
        • 3.3.4.1  By Attribute
        • 3.3.4.2  By primary type
        • 3.3.4.3  By secondary type
      • 3.3.5  ATK
      • 3.3.6  DEF
      • 3.3.7  Level/Rank
        • 3.3.7.1  ATK statistics
        • 3.3.7.2  DEF statistics
      • 3.3.8  Pendulum scale
        • 3.3.8.1  ATK statistics
        • 3.3.8.2  DEF statistics
        • 3.3.8.3  Level/Rank statistics
      • 3.3.9  Link
        • 3.3.9.1  ATK statistics
      • 3.3.10  Link Arrows
        • 3.3.10.1  By combination
        • 3.3.10.2  By unique
        • 3.3.10.3  By link
    • 3.4  Spell & Trap
      • 3.4.1  Properties
    • 3.5  Effect type
      • 3.5.1  Card type discrimination
    • 3.6  Archseries
      • 3.6.1  By card type
      • 3.6.2  By primary type
      • 3.6.3  By secondary type
      • 3.6.4  By monster type
      • 3.6.5  By property
    • 3.7  Artworks
      • 3.7.1  By card type
      • 3.7.2  By primary type
    • 3.8  Errata
      • 3.8.1  By card type
      • 3.8.2  By primary type
      • 3.8.3  By artwork
    • 3.9  TCG & OCG status
      • 3.9.1  TGC status
        • 3.9.1.1  By card type
        • 3.9.1.2  By monster type
        • 3.9.1.3  By archseries
      • 3.9.2  OCG status
        • 3.9.2.1  By card type
        • 3.9.2.2  By monster type
        • 3.9.2.3  By archseries
      • 3.9.3  TCG vs. OCG status
  • 4  Extras
    • 4.1 Multiple secondary types
    • 4.2 Not yet released
    • 4.3 Counters and Tokens
  • 5  Epilogue
    • 5.1  HTML export

Data aquisition¶

Fetch online data¶

Downloading monsters










8393 results



































Downloading Spells




















2549 results





















Downloading Traps




















1911 results



































Downloading tokens




















165 results





















Downloading counters




















15 results





















Downloading all errata




















/home/jovyan/yugiquery/source/yugiquery.py:2381: FutureWarning: Downcasting object dtype arrays on .fillna, .ffill, .bfill is deprecated and will change in a future version. Call result.infer_objects(copy=False) instead. To opt-in to the future behavior, set `pd.set_option('future.no_silent_downcasting', True)`
  pd.concat([errata_df, errata_series], axis=1).fillna(False).sort_index()











/home/jovyan/yugiquery/source/yugiquery.py:2381: FutureWarning: Downcasting object dtype arrays on .fillna, .ffill, .bfill is deprecated and will change in a future version. Call result.infer_objects(copy=False) instead. To opt-in to the future behavior, set `pd.set_option('future.no_silent_downcasting', True)`
  pd.concat([errata_df, errata_series], axis=1).fillna(False).sort_index()











5069 results

































Merge data¶






















Data merged
































Check changes¶




















Load previous data¶






















cards file loaded
































Generate changelog¶






















/home/jovyan/yugiquery/source/yugiquery.py:1101: FutureWarning: A value is trying to be set on a copy of a DataFrame or Series through chained assignment using an inplace method.
The behavior will change in pandas 3.0. This inplace method will never work because the intermediate object on which we are setting values always behaves as a copy.

For example, when doing 'df[col].method(value, inplace=True)', try using 'df.method({col: value}, inplace=True)' or df[col] = df[col].method(value) instead, to perform the operation inplace on the original object.


  changelog["_merge"].replace(











/home/jovyan/yugiquery/source/yugiquery.py:1101: FutureWarning: The behavior of Series.replace (and DataFrame.replace) with CategoricalDtype is deprecated. In a future version, replace will only be used for cases that preserve the categories. To change the categories, use ser.cat.rename_categories instead.
  changelog["_merge"].replace(


















Password
Archseries
OCG status
Artwork
Modification date
Errata
Version




Name










Loading... (need help?)













Changelog saved
































Save data¶






















Data saved
































Data visualization¶




















Full data¶




























Name
Password
Card type
Property
Archseries
Effect type
TCG status
OCG status
Page name
Page URL
Artwork
Modification date
Errata
Attribute
Primary type
Secondary type
Monster type
DEF
Pendulum Scale
Link
Link Arrows
ATK
Level/Rank



Loading... (need help?)

























Full data available to download here




















Card types¶






















Total number of card types:










 










3

































No description has been provided for this image





















Monsters¶




















Attributes¶






















Total number of attributes:










 










7









































Name
Password
Archseries
Primary type
Secondary type
Monster type
Effect type
DEF
Pendulum Scale
Link
Link Arrows
ATK
Level/Rank
TCG status
OCG status
Artwork
Modification date
Errata




Attribute





















Loading... (need help?)


























No description has been provided for this image





















Primary types¶






















Total number of primary types:










 










7









































Name
Password
Archseries
Attribute
Secondary type
Monster type
Effect type
DEF
Pendulum Scale
Link
Link Arrows
ATK
Level/Rank
TCG status
OCG status
Artwork
Modification date
Errata




Primary type





















Loading... (need help?)

























Has effect discrimination¶




























Has effect
Effect
No Effect




Primary type





Loading... (need help?)


























No description has been provided for this image





















Obs: Normal monster can have effect if it is pendulum




















Is pendulum discrimination¶




























Is Pendulum
Pendulum
Not Pendulum




Primary type





Loading... (need help?)


























No description has been provided for this image





















By attribute¶




























Attribute
DARK
DIVINE
EARTH
FIRE
LIGHT
WATER
WIND




Primary type










Loading... (need help?)


























No description has been provided for this image





















Secondary types¶






















Total number of secondary types:










 










6









































Name
Password
Archseries
Attribute
Primary type
Monster type
Effect type
DEF
Pendulum Scale
ATK
Level/Rank
TCG status
OCG status
Artwork
Modification date
Errata




Secondary type



















Loading... (need help?)


























No description has been provided for this image





















By attribute¶




























Attribute
DARK
EARTH
FIRE
LIGHT
WATER
WIND




Secondary type









Loading... (need help?)


























No description has been provided for this image





















By secondary type¶




























Secondary type
Flip monster
Gemini monster
Spirit monster
Toon monster
Tuner monster
Union monster
All




Primary type










Loading... (need help?)


























No description has been provided for this image





















Monster types¶






















Total number of monster types:










 










26









































Name
Password
Archseries
Attribute
Primary type
Secondary type
Effect type
DEF
Pendulum Scale
Link
Link Arrows
ATK
Level/Rank
TCG status
OCG status
Artwork
Modification date
Errata




Monster type





















Loading... (need help?)


























No description has been provided for this image





















By Attribute¶




























Attribute
DARK
DIVINE
EARTH
FIRE
LIGHT
WATER
WIND




Monster type










Loading... (need help?)


























No description has been provided for this image





















By primary type¶




























Primary type
Effect Monster
Fusion Monster
Link Monster
Normal Monster
Ritual Monster
Synchro Monster
Xyz Monster
nan




Monster type











Loading... (need help?)


























No description has been provided for this image





















By secondary type¶




























Secondary type
Flip monster
Gemini monster
Spirit monster
Toon monster
Tuner monster
Union monster
nan




Monster type










Loading... (need help?)


























No description has been provided for this image





















ATK¶






















Total number of ATK values:










 










83









































Name
Password
Archseries
Attribute
Primary type
Secondary type
Monster type
Effect type
DEF
Pendulum Scale
Link
Link Arrows
Level/Rank
TCG status
OCG status
Artwork
Modification date
Errata




ATK





















Loading... (need help?)


























No description has been provided for this image





















DEF¶






















Total number of DEF values:










 










78









































Name
Password
Archseries
Attribute
Primary type
Secondary type
Monster type
Effect type
Pendulum Scale
Link
Link Arrows
ATK
Level/Rank
TCG status
OCG status
Artwork
Modification date
Errata




DEF





















Loading... (need help?)


























No description has been provided for this image





















Level/Rank¶





























Name
Password
Archseries
Attribute
Primary type
Secondary type
Monster type
Effect type
DEF
Pendulum Scale
ATK
TCG status
OCG status
Artwork
Modification date
Errata




Level/Rank



















Loading... (need help?)


























No description has been provided for this image





















ATK statistics¶





























ATK





count
mean
std
min
25%
50%
75%
max




Level/Rank











Loading... (need help?)

























DEF statistics¶





























DEF





count
mean
std
min
25%
50%
75%
max




Level/Rank











Loading... (need help?)

























Pendulum scale¶





























Name
Password
Archseries
Attribute
Primary type
Secondary type
Monster type
Effect type
DEF
ATK
Level/Rank
TCG status
OCG status
Artwork
Modification date
Errata




Pendulum Scale



















Loading... (need help?)


























No description has been provided for this image





















ATK statistics¶





























ATK





count
mean
std
min
25%
50%
75%
max




Pendulum Scale











Loading... (need help?)

























DEF statistics¶





























DEF





count
mean
std
min
25%
50%
75%
max




Pendulum Scale











Loading... (need help?)

























Level/Rank statistics¶





























Level/Rank





count
mean
std
min
25%
50%
75%
max




Pendulum Scale











Loading... (need help?)

























Link¶





























Name
Password
Archseries
Attribute
Monster type
Effect type
Link Arrows
ATK
TCG status
OCG status
Artwork
Modification date
Errata




Link
















Loading... (need help?)


























No description has been provided for this image





















ATK statistics¶





























ATK





count
mean
std
min
25%
50%
75%
max




Link











Loading... (need help?)

























Link Arrows¶




















By combination¶






















Total number of link arrow combinations:










 










63









































Name
Password
Archseries
Attribute
Monster type
Effect type
ATK
TCG status
OCG status
Artwork
Modification date
Errata




Link Arrows















Loading... (need help?)


























No description has been provided for this image





















By unique¶





























Name
Password
Archseries
Attribute
Monster type
Effect type
Link
ATK
TCG status
OCG status
Artwork
Modification date
Errata




Link Arrows
















Loading... (need help?)


























No description has been provided for this image





















By link¶




























Link
1
2
3
4
5
6




Link Arrows









Loading... (need help?)


























No description has been provided for this image





















Spell & Trap¶




















Properties¶






















Total number of properties:










 










9









































Name
Password
Archseries
Effect type
TCG status
OCG status
Artwork
Modification date
Errata




Property












Loading... (need help?)


























No description has been provided for this image





















Effect type¶






















Total number of effect types:










 










16









































Name
Password
Card type
Property
Archseries
TCG status
OCG status
Page name
Page URL
Artwork
Modification date
Errata
Attribute
Primary type
Secondary type
Monster type
DEF
Pendulum Scale
Link
Link Arrows
ATK
Level/Rank




Effect type

























Loading... (need help?)

























Card type discrimination¶




























Card type
Monster Card
Spell Card
Trap Card




Effect type






Loading... (need help?)


























No description has been provided for this image





















Archseries¶






















Total number of Archseries:










 










760









































Name
Password
Card type
Property
Effect type
TCG status
OCG status
Page name
Page URL
Artwork
Modification date
Errata
Attribute
Primary type
Secondary type
Monster type
DEF
Pendulum Scale
Link
Link Arrows
ATK
Level/Rank




Archseries

























Loading... (need help?)


























No description has been provided for this image





















By card type¶




























Card type
Monster Card
Spell Card
Trap Card
All




Archseries







Loading... (need help?)

























By primary type¶




























Primary type
Effect Monster
Fusion Monster
Link Monster
Normal Monster
Ritual Monster
Synchro Monster
Xyz Monster
All




Archseries











Loading... (need help?)

























By secondary type¶




























Secondary type
Flip monster
Gemini monster
Spirit monster
Toon monster
Tuner monster
Union monster
All




Archseries










Loading... (need help?)

























By monster type¶




























Monster type
Aqua
Beast
Beast-Warrior
Creator God
Cyberse
Dinosaur
Divine-Beast
Dragon
Fairy
Fiend
Fish
Illusion
Insect
Machine
Plant
Psychic
Pyro
Reptile
Rock
Sea Serpent
Spellcaster
Thunder
Warrior
Winged Beast
Wyrm
Zombie
All




Archseries






























Loading... (need help?)

























By property¶




























Property
Continuous Spell Card
Continuous Trap Card
Counter Trap Card
Equip Spell Card
Field Spell Card
Normal Spell Card
Normal Trap Card
Quick-Play Spell Card
Ritual Spell Card
All




Archseries













Loading... (need help?)

























Artworks¶






















Total number of cards with edited or alternate artworks:










 










700









































Name
Password
TCG status
OCG status
Artwork



Loading... (need help?)


























No description has been provided for this image





















By card type¶




























Card type
Monster Card
Spell Card
Trap Card




Artwork






Loading... (need help?)

























By primary type¶




























Primary type
Effect Monster
Fusion Monster
Link Monster
Normal Monster
Ritual Monster
Synchro Monster
Xyz Monster




Artwork










Loading... (need help?)

























More granularity is unnecessary




















Errata¶






















Total number of cards with errata:










 










4936









































Name
Password
TCG status
OCG status
Errata



Loading... (need help?)


































Name
Password
Card type
Property
Archseries
Effect type
TCG status
OCG status
Page name
Page URL
Artwork
Modification date
Attribute
Primary type
Secondary type
Monster type
DEF
Pendulum Scale
Link
Link Arrows
ATK
Level/Rank




Errata

























Loading... (need help?)


























No description has been provided for this image





















By card type¶




























Card type
Monster Card
Spell Card
Trap Card




Errata






Loading... (need help?)

























By primary type¶




























Primary type
Effect Monster
Fusion Monster
Link Monster
Normal Monster
Ritual Monster
Synchro Monster
Xyz Monster




Errata










Loading... (need help?)

























More granularity is unnecessary




















By artwork¶




























Errata
(Any,)
(Name,)
(Name, Type)
(Type,)




Artwork







Loading... (need help?)

























TCG & OCG status¶




















TGC status¶






















Total number of TCG status:










 










6









































Name
Password
Card type
Property
Archseries
Effect type
OCG status
Artwork
Modification date
Errata
Attribute
Primary type
Secondary type
Monster type
DEF
Pendulum Scale
Link
Link Arrows
ATK
Level/Rank




TCG status























Loading... (need help?)


























No description has been provided for this image





















By card type¶




























TCG status
Forbidden
Illegal
Limited
Not yet released
Semi-Limited




Card type








Loading... (need help?)


























No description has been provided for this image





















By monster type¶




























TCG status
Forbidden
Illegal
Limited
Not yet released
Semi-Limited




Monster type








Loading... (need help?)


























No description has been provided for this image





















By archseries¶




























TCG status
Forbidden
Illegal
Limited
Not yet released
Semi-Limited
Unlimited
All




Archseries










Loading... (need help?)

























OCG status¶






















Total number of OCG status:










 










6









































Name
Password
Card type
Property
Archseries
Effect type
TCG status
Artwork
Modification date
Errata
Attribute
Primary type
Secondary type
Monster type
DEF
Pendulum Scale
Link
Link Arrows
ATK
Level/Rank




OCG status























Loading... (need help?)


























No description has been provided for this image





















By card type¶




























OCG status
Forbidden
Illegal
Limited
Not yet released
Semi-Limited




Card type








Loading... (need help?)


























No description has been provided for this image





















By monster type¶




























OCG status
Forbidden
Illegal
Limited
Not yet released
Semi-Limited




Monster type








Loading... (need help?)


























No description has been provided for this image





















By archseries¶




























OCG status
Forbidden
Illegal
Limited
Not yet released
Semi-Limited
All




Archseries









Loading... (need help?)

























TCG vs. OCG status¶




























TCG status
Forbidden
Illegal
Limited
Not yet released
Semi-Limited
Unlimited
nan




OCG status










Loading... (need help?)


























No description has been provided for this image





















Extras¶




















Multiple secondary types¶





























Name
Password
Card type
Property
Archseries
Effect type
TCG status
OCG status
Page name
Page URL
Artwork
Modification date
Errata
Attribute
Primary type
Secondary type
Monster type
DEF
Pendulum Scale
Link
Link Arrows
ATK
Level/Rank



Loading... (need help?)

























Not yet released¶





























Name
Password
Card type
Property
Archseries
Effect type
TCG status
OCG status
Page name
Page URL
Artwork
Modification date
Errata
Attribute
Primary type
Secondary type
Monster type
DEF
Pendulum Scale
Link
Link Arrows
ATK
Level/Rank



Loading... (need help?)

























Counters and Tokens¶




























Name
Card type
Archseries
Attribute
Primary type
Monster type
Effect type
DEF
ATK
Level/Rank
TCG status
OCG status
Page name
Page URL
Artwork
Modification date
Errata



Loading... (need help?)

























Page name differs from card name¶





























Name
Password
Card type
Property
Archseries
Effect type
TCG status
OCG status
Page name
Page URL
Artwork
Modification date
Errata
Attribute
Primary type
Secondary type
Monster type
DEF
Pendulum Scale
Link
Link Arrows
ATK
Level/Rank



Loading... (need help?)

























Epilogue¶

























    Execution completed 05/02/2024 05:06 UTC























HTML export¶






















Notebook saved to disk